Hotel Bookings Report

Dataset statistics

Number of variables	24
Number of observations	66541
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	4
Duplicate rows (%)	< 0.1%
Total size in memory	55.0 MiB
Average record size in memory	867.1 B

Variable types

Text	6
DateTime	3
Unsupported	1
Categorical	7
Numeric	7

Alerts

`Taxes (GST)` has constant value ""	Constant
Dataset has 4 (< 0.1%) duplicate rows	Duplicates
`Booking Price[SGD]` is highly overall correlated with `Hotel Rating`	High correlation
`Hotel Rating` is highly overall correlated with `Booking Price[SGD]`	High correlation
`No. Of People` is highly overall correlated with `Rooms`	High correlation
`Rooms` is highly overall correlated with `No. Of People`	High correlation
`Time` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Discount` has 2547 (3.8%) zeros	Zeros

Reproduction

Analysis started	2024-02-28 13:58:11.508334
Analysis finished	2024-02-28 13:58:34.704642
Duration	23.2 seconds
Software version	ydata-profiling vv4.6.5
Download configuration	config.json

Booking ID
Text

Distinct	66536
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	598869
Distinct characters	23
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	66532 ?
Unique (%)	> 99.9%

Sample

1st row	DDMY00001
2nd row	DDID00002
3rd row	DDSG00003
4th row	DDSG00004
5th row	DDKH00005

Value	Count	Frequency (%)
ddvn34340	3	< 0.1%
ddsg22537	2	< 0.1%
ddkh50738	2	< 0.1%
ddmy00008	2	< 0.1%
ddvn00031	1	< 0.1%
ddkh00034	1	< 0.1%
ddvn00033	1	< 0.1%
ddsg00017	1	< 0.1%
ddsg00003	1	< 0.1%
ddsg00004	1	< 0.1%
Other values (66526)	66526	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
D	145068	24.2%
2	37016	6.2%
3	37016	6.2%
0	37016	6.2%
1	37014	6.2%
4	37008	6.2%
5	36943	6.2%
6	32978	5.5%
7	25906	4.3%
8	25905	4.3%
Other values (13)	146999	24.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	332705	55.6%
Uppercase Letter	266164	44.4%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
D	145068	54.5%
H	24507	9.2%
T	12170	4.6%
M	12050	4.5%
Y	12050	4.5%
G	12037	4.5%
S	12037	4.5%
I	11986	4.5%
P	6383	2.4%
V	5961	2.2%
Other values (3)	11915	4.5%

Decimal Number

Value	Count	Frequency (%)
2	37016	11.1%
3	37016	11.1%
0	37016	11.1%
1	37014	11.1%
4	37008	11.1%
5	36943	11.1%
6	32978	9.9%
7	25906	7.8%
8	25905	7.8%
9	25903	7.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	332705	55.6%
Latin	266164	44.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	145068	54.5%
H	24507	9.2%
T	12170	4.6%
M	12050	4.5%
Y	12050	4.5%
G	12037	4.5%
S	12037	4.5%
I	11986	4.5%
P	6383	2.4%
V	5961	2.2%
Other values (3)	11915	4.5%

Common

Value	Count	Frequency (%)
2	37016	11.1%
3	37016	11.1%
0	37016	11.1%
1	37014	11.1%
4	37008	11.1%
5	36943	11.1%
6	32978	9.9%
7	25906	7.8%
8	25905	7.8%
9	25903	7.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	598869	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
D	145068	24.2%
2	37016	6.2%
3	37016	6.2%
0	37016	6.2%
1	37014	6.2%
4	37008	6.2%
5	36943	6.2%
6	32978	5.5%
7	25906	4.3%
8	25905	4.3%
Other values (13)	146999	24.5%

Date of Booking
Date

Distinct	3652
Distinct (%)	5.5%
Missing	0
Missing (%)	0.0%
Memory size	520.0 KiB

Minimum	2010-01-01 00:00:00
Maximum	2019-12-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Time
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

Customer ID
Text

Distinct	66536
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Memory size	4.1 MiB

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	465787
Distinct characters	23
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	66532 ?
Unique (%)	> 99.9%

Sample

1st row	MY00001
2nd row	ID00001
3rd row	SG00001
4th row	SG00002
5th row	KH00001

Value	Count	Frequency (%)
vn03010	3	< 0.1%
sg04062	2	< 0.1%
kh04520	2	< 0.1%
my00002	2	< 0.1%
vn00003	1	< 0.1%
kh00004	1	< 0.1%
vn00004	1	< 0.1%
sg00005	1	< 0.1%
sg00001	1	< 0.1%
sg00002	1	< 0.1%
Other values (66526)	66526	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
0	89500	19.2%
1	39342	8.4%
2	27298	5.9%
3	27019	5.8%
4	26927	5.8%
5	26822	5.8%
H	24506	5.3%
6	24279	5.2%
7	23883	5.1%
8	23873	5.1%
Other values (13)	132338	28.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	332705	71.4%
Uppercase Letter	133082	28.6%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
H	24506	18.4%
T	12170	9.1%
Y	12050	9.1%
M	12050	9.1%
G	12037	9.0%
S	12037	9.0%
D	11987	9.0%
I	11986	9.0%
P	6383	4.8%
V	5961	4.5%
Other values (3)	11915	9.0%

Decimal Number

Value	Count	Frequency (%)
0	89500	26.9%
1	39342	11.8%
2	27298	8.2%
3	27019	8.1%
4	26927	8.1%
5	26822	8.1%
6	24279	7.3%
7	23883	7.2%
8	23873	7.2%
9	23762	7.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	332705	71.4%
Latin	133082	28.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
H	24506	18.4%
T	12170	9.1%
Y	12050	9.1%
M	12050	9.1%
G	12037	9.0%
S	12037	9.0%
D	11987	9.0%
I	11986	9.0%
P	6383	4.8%
V	5961	4.5%
Other values (3)	11915	9.0%

Common

Value	Count	Frequency (%)
0	89500	26.9%
1	39342	11.8%
2	27298	8.2%
3	27019	8.1%
4	26927	8.1%
5	26822	8.1%
6	24279	7.3%
7	23883	7.2%
8	23873	7.2%
9	23762	7.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	465787	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	89500	19.2%
1	39342	8.4%
2	27298	5.9%
3	27019	5.8%
4	26927	5.8%
5	26822	5.8%
H	24506	5.3%
6	24279	5.2%
7	23883	5.1%
8	23873	5.1%
Other values (13)	132338	28.4%

Gender
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.9 MiB

Female	33388
Male	33153

Length

Max length	6
Median length	6
Mean length	5.0035317
Min length	4

Characters and Unicode

Total characters	332940
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Male
2nd row	Female
3rd row	Female
4th row	Male
5th row	Male

Common Values

Value	Count	Frequency (%)
Female	33388	50.2%
Male	33153	49.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
female	33388	50.2%
male	33153	49.8%

Most occurring characters

Value	Count	Frequency (%)
e	99929	30.0%
a	66541	20.0%
l	66541	20.0%
F	33388	10.0%
m	33388	10.0%
M	33153	10.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	266399	80.0%
Uppercase Letter	66541	20.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	99929	37.5%
a	66541	25.0%
l	66541	25.0%
m	33388	12.5%

Uppercase Letter

Value	Count	Frequency (%)
F	33388	50.2%
M	33153	49.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	332940	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	99929	30.0%
a	66541	20.0%
l	66541	20.0%
F	33388	10.0%
m	33388	10.0%
M	33153	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	332940	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	99929	30.0%
a	66541	20.0%
l	66541	20.0%
F	33388	10.0%
m	33388	10.0%
M	33153	10.0%

Age
Real number (ℝ)

Distinct	41
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.436182

Minimum	-5
Maximum	58
Zeros	0
Zeros (%)	0.0%
Negative	1
Negative (%)	< 0.1%
Memory size	520.0 KiB

Quantile statistics

Minimum	-5
5-th percentile	21
Q1	28
median	38
Q3	48
95-th percentile	57
Maximum	58
Range	63
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	11.557562
Coefficient of variation (CV)	0.30069486
Kurtosis	-1.199354
Mean	38.436182
Median Absolute Deviation (MAD)	10
Skewness	0.010175915
Sum	2557582
Variance	133.57725
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
22	1776	2.7%
56	1754	2.6%
25	1742	2.6%
28	1735	2.6%
44	1732	2.6%
47	1726	2.6%
46	1723	2.6%
19	1722	2.6%
58	1721	2.6%
33	1715	2.6%
Other values (31)	49195	73.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-5	1	< 0.1%
19	1722	2.6%
20	1601	2.4%
21	1645	2.5%
22	1776	2.7%
23	1630	2.4%
24	1645	2.5%
25	1742	2.6%
26	1651	2.5%
27	1647	2.5%

Value	Count	Frequency (%)
58	1721	2.6%
57	1611	2.4%
56	1754	2.6%
55	1617	2.4%
54	1671	2.5%
53	1598	2.4%
52	1607	2.4%
51	1659	2.5%
50	1651	2.5%
49	1594	2.4%

Origin Country
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Thailand	12170
Malaysia	12050
Singapore	12038
Indonesia	11986
Philippines	6383
Other values (2)	11914

Length

Max length	11
Median length	9
Mean length	8.5592342
Min length	7

Characters and Unicode

Total characters	569540
Distinct characters	23
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Malaysia
2nd row	Indonesia
3rd row	Singapore
4th row	Singapore
5th row	Cambodia

Common Values

Value	Count	Frequency (%)
Thailand	12170	18.3%
Malaysia	12050	18.1%
Singapore	12038	18.1%
Indonesia	11986	18.0%
Philippines	6383	9.6%
Vietnam	5961	9.0%
Cambodia	5953	8.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
thailand	12170	18.3%
malaysia	12050	18.1%
singapore	12038	18.1%
indonesia	11986	18.0%
philippines	6383	9.6%
vietnam	5961	9.0%
cambodia	5953	8.9%

Most occurring characters

Value	Count	Frequency (%)
a	102381	18.0%
i	79307	13.9%
n	60524	10.6%
e	36368	6.4%
l	30603	5.4%
s	30419	5.3%
d	30109	5.3%
o	29977	5.3%
p	24804	4.4%
h	18553	3.3%
Other values (13)	126495	22.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	502999	88.3%
Uppercase Letter	66541	11.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	102381	20.4%
i	79307	15.8%
n	60524	12.0%
e	36368	7.2%
l	30603	6.1%
s	30419	6.0%
d	30109	6.0%
o	29977	6.0%
p	24804	4.9%
h	18553	3.7%
Other values (6)	59954	11.9%

Uppercase Letter

Value	Count	Frequency (%)
T	12170	18.3%
M	12050	18.1%
S	12038	18.1%
I	11986	18.0%
P	6383	9.6%
V	5961	9.0%
C	5953	8.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	569540	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	102381	18.0%
i	79307	13.9%
n	60524	10.6%
e	36368	6.4%
l	30603	5.4%
s	30419	5.3%
d	30109	5.3%
o	29977	5.3%
p	24804	4.4%
h	18553	3.3%
Other values (13)	126495	22.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	569540	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	102381	18.0%
i	79307	13.9%
n	60524	10.6%
e	36368	6.4%
l	30603	5.4%
s	30419	5.3%
d	30109	5.3%
o	29977	5.3%
p	24804	4.4%
h	18553	3.3%
Other values (13)	126495	22.2%

State
Text

Distinct	219
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	4.1 MiB

Length

Max length	14
Median length	11
Mean length	7.4767887
Min length	3

Characters and Unicode

Total characters	497513
Distinct characters	50
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Johor
2nd row	Ciawi
3rd row	Central
4th row	North
5th row	Phnom Trop

Value	Count	Frequency (%)
central	4821	5.7%
west	2617	3.1%
sarawak	1884	2.2%
johor	1863	2.2%
penang	1847	2.2%
north	1799	2.1%
selangor	1793	2.1%
thani	1757	2.1%
north-east	1461	1.7%
chonburi	1350	1.6%
Other values (262)	63007	74.8%

Most occurring characters

Value	Count	Frequency (%)
a	80820	16.2%
n	45842	9.2%
e	29429	5.9%
o	29161	5.9%
r	28803	5.8%
h	25047	5.0%
t	24806	5.0%
g	19896	4.0%
i	18063	3.6%
u	17867	3.6%
Other values (40)	177779	35.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	392734	78.9%
Uppercase Letter	85660	17.2%
Space Separator	17658	3.5%
Dash Punctuation	1461	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	80820	20.6%
n	45842	11.7%
e	29429	7.5%
o	29161	7.4%
r	28803	7.3%
h	25047	6.4%
t	24806	6.3%
g	19896	5.1%
i	18063	4.6%
u	17867	4.5%
Other values (14)	73000	18.6%

Uppercase Letter

Value	Count	Frequency (%)
S	13064	15.3%
C	10127	11.8%
P	10118	11.8%
T	9002	10.5%
N	7380	8.6%
K	5443	6.4%
B	4565	5.3%
M	4318	5.0%
E	3100	3.6%
L	2863	3.3%
Other values (14)	15680	18.3%

Space Separator

Value	Count	Frequency (%)
	17658	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1461	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	478394	96.2%
Common	19119	3.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	80820	16.9%
n	45842	9.6%
e	29429	6.2%
o	29161	6.1%
r	28803	6.0%
h	25047	5.2%
t	24806	5.2%
g	19896	4.2%
i	18063	3.8%
u	17867	3.7%
Other values (38)	158660	33.2%

Common

Value	Count	Frequency (%)
	17658	92.4%
-	1461	7.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	497513	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	80820	16.2%
n	45842	9.2%
e	29429	5.9%
o	29161	5.9%
r	28803	5.8%
h	25047	5.0%
t	24806	5.0%
g	19896	4.0%
i	18063	3.6%
u	17867	3.6%
Other values (40)	177779	35.7%

Location
Text

Distinct	228
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Length

Max length	23
Median length	15
Mean length	9.3061721
Min length	4

Characters and Unicode

Total characters	619242
Distinct characters	52
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Iskandar Puteri
2nd row	West Java
3rd row	Rochor
4th row	Yishun
5th row	Pursat

Value	Count	Frequency (%)
jakarta	3519	3.3%
java	3082	2.9%
west	2425	2.3%
binh	1700	1.6%
east	1605	1.5%
central	1512	1.4%
papua	1458	1.4%
nakhon	1281	1.2%
kampong	1112	1.0%
kuching	985	0.9%
Other values (284)	87950	82.5%

Most occurring characters

Value	Count	Frequency (%)
a	105023	17.0%
n	46782	7.6%
	40088	6.5%
e	34273	5.5%
o	30788	5.0%
r	30421	4.9%
t	30245	4.9%
i	29229	4.7%
h	26787	4.3%
g	23069	3.7%
Other values (42)	222537	35.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	471537	76.1%
Uppercase Letter	107080	17.3%
Space Separator	40088	6.5%
Dash Punctuation	537	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	105023	22.3%
n	46782	9.9%
e	34273	7.3%
o	30788	6.5%
r	30421	6.5%
t	30245	6.4%
i	29229	6.2%
h	26787	5.7%
g	23069	4.9%
u	22760	4.8%
Other values (15)	92160	19.5%

Uppercase Letter

Value	Count	Frequency (%)
S	12758	11.9%
P	10874	10.2%
K	10104	9.4%
J	9634	9.0%
T	9035	8.4%
C	7855	7.3%
B	6973	6.5%
M	5500	5.1%
N	5259	4.9%
W	3552	3.3%
Other values (14)	25536	23.8%

Dash Punctuation

Value	Count	Frequency (%)
-	462	86.0%
‑	75	14.0%

Space Separator

Value	Count	Frequency (%)
	40088	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	578617	93.4%
Common	40625	6.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	105023	18.2%
n	46782	8.1%
e	34273	5.9%
o	30788	5.3%
r	30421	5.3%
t	30245	5.2%
i	29229	5.1%
h	26787	4.6%
g	23069	4.0%
u	22760	3.9%
Other values (39)	199240	34.4%

Common

Value	Count	Frequency (%)
	40088	98.7%
-	462	1.1%
‑	75	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	618943	> 99.9%
Latin 1 Sup	224	< 0.1%
Punctuation	75	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	105023	17.0%
n	46782	7.6%
	40088	6.5%
e	34273	5.5%
o	30788	5.0%
r	30421	4.9%
t	30245	4.9%
i	29229	4.7%
h	26787	4.3%
g	23069	3.7%
Other values (40)	222238	35.9%

Latin 1 Sup

Value	Count	Frequency (%)
ñ	224	100.0%

Punctuation

Value	Count	Frequency (%)
‑	75	100.0%

Destination Country
Categorical

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.0 MiB

New Zealand	3448
Nepal	3446
Egypt	3423
Colombia	3408
China	3391
Other values (15)	49425

Length

Max length	11
Median length	8
Mean length	6.2133572
Min length	4

Characters and Unicode

Total characters	413443
Distinct characters	35
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Denmark
2nd row	Colombia
3rd row	Germany
4th row	Canada
5th row	Kenya

Common Values

Value	Count	Frequency (%)
New Zealand	3448	5.2%
Nepal	3446	5.2%
Egypt	3423	5.1%
Colombia	3408	5.1%
China	3391	5.1%
Denmark	3375	5.1%
Israel	3356	5.0%
France	3346	5.0%
Iceland	3344	5.0%
Italy	3342	5.0%
Other values (10)	32662	49.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
new	3448	4.9%
zealand	3448	4.9%
nepal	3446	4.9%
egypt	3423	4.9%
colombia	3408	4.9%
china	3391	4.8%
denmark	3375	4.8%
israel	3356	4.8%
france	3346	4.8%
iceland	3344	4.8%
Other values (11)	36004	51.4%

Most occurring characters

Value	Count	Frequency (%)
a	73226	17.7%
e	40135	9.7%
n	39803	9.6%
l	30166	7.3%
r	23107	5.6%
d	19995	4.8%
i	19853	4.8%
I	19821	4.8%
y	13299	3.2%
C	10130	2.5%
Other values (25)	123908	30.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	340006	82.2%
Uppercase Letter	69989	16.9%
Space Separator	3448	0.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	73226	21.5%
e	40135	11.8%
n	39803	11.7%
l	30166	8.9%
r	23107	6.8%
d	19995	5.9%
i	19853	5.8%
y	13299	3.9%
p	10124	3.0%
m	10084	3.0%
Other values (12)	60214	17.7%

Uppercase Letter

Value	Count	Frequency (%)
I	19821	28.3%
C	10130	14.5%
N	6894	9.9%
M	6522	9.3%
Z	3448	4.9%
E	3423	4.9%
D	3375	4.8%
F	3346	4.8%
G	3301	4.7%
J	3255	4.7%
Other values (2)	6474	9.3%

Space Separator

Value	Count	Frequency (%)
	3448	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	409995	99.2%
Common	3448	0.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	73226	17.9%
e	40135	9.8%
n	39803	9.7%
l	30166	7.4%
r	23107	5.6%
d	19995	4.9%
i	19853	4.8%
I	19821	4.8%
y	13299	3.2%
C	10130	2.5%
Other values (24)	120460	29.4%

Common

Value	Count	Frequency (%)
	3448	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	413443	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	73226	17.7%
e	40135	9.7%
n	39803	9.6%
l	30166	7.3%
r	23107	5.6%
d	19995	4.8%
i	19853	4.8%
I	19821	4.8%
y	13299	3.2%
C	10130	2.5%
Other values (25)	123908	30.0%

Destination City
Text

Distinct	120
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	4.1 MiB

Length

Max length	14
Median length	11
Mean length	6.9708901
Min length	3

Characters and Unicode

Total characters	463850
Distinct characters	50
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Horsens
2nd row	Medellin
3rd row	Munich
4th row	Montreal
5th row	Nairobi

Value	Count	Frequency (%)
city	1094	1.6%
hamilton	1084	1.6%
bello	646	0.9%
horizonte	635	0.9%
belo	635	0.9%
dublin	628	0.9%
auckland	624	0.9%
shanghai	620	0.9%
toronto	608	0.9%
haifa	607	0.9%
Other values (115)	62710	89.7%

Most occurring characters

Value	Count	Frequency (%)
a	62260	13.4%
o	35034	7.6%
e	33275	7.2%
r	33046	7.1%
i	31744	6.8%
n	29936	6.5%
l	24615	5.3%
u	18975	4.1%
t	16942	3.7%
h	13836	3.0%
Other values (40)	164187	35.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	390609	84.2%
Uppercase Letter	69891	15.1%
Space Separator	3350	0.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	62260	15.9%
o	35034	9.0%
e	33275	8.5%
r	33046	8.5%
i	31744	8.1%
n	29936	7.7%
l	24615	6.3%
u	18975	4.9%
t	16942	4.3%
h	13836	3.5%
Other values (16)	90946	23.3%

Uppercase Letter

Value	Count	Frequency (%)
M	7102	10.2%
B	6324	9.0%
H	6095	8.7%
T	5175	7.4%
A	5059	7.2%
N	4370	6.3%
C	4363	6.2%
K	3890	5.6%
S	3867	5.5%
G	3767	5.4%
Other values (13)	19879	28.4%

Space Separator

Value	Count	Frequency (%)
	3350	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	460500	99.3%
Common	3350	0.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	62260	13.5%
o	35034	7.6%
e	33275	7.2%
r	33046	7.2%
i	31744	6.9%
n	29936	6.5%
l	24615	5.3%
u	18975	4.1%
t	16942	3.7%
h	13836	3.0%
Other values (39)	160837	34.9%

Common

Value	Count	Frequency (%)
	3350	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	463306	99.9%
Latin 1 Sup	544	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	62260	13.4%
o	35034	7.6%
e	33275	7.2%
r	33046	7.1%
i	31744	6.9%
n	29936	6.5%
l	24615	5.3%
u	18975	4.1%
t	16942	3.7%
h	13836	3.0%
Other values (39)	163643	35.3%

Latin 1 Sup

Value	Count	Frequency (%)
í	544	100.0%

No. Of People
Real number (ℝ)

HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.995777

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	520.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.0000744
Coefficient of variation (CV)	0.50054706
Kurtosis	-1.2494204
Mean	3.995777
Median Absolute Deviation (MAD)	2
Skewness	0.0068885372
Sum	265883
Variance	4.0002978
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	9593	14.4%
4	9554	14.4%
7	9548	14.3%
3	9541	14.3%
1	9477	14.2%
5	9423	14.2%
6	9405	14.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9477	14.2%
2	9593	14.4%
3	9541	14.3%
4	9554	14.4%
5	9423	14.2%
6	9405	14.1%
7	9548	14.3%

Value	Count	Frequency (%)
7	9548	14.3%
6	9405	14.1%
5	9423	14.2%
4	9554	14.4%
3	9541	14.3%
2	9593	14.4%
1	9477	14.2%

Check-in date
Date

Distinct	3747
Distinct (%)	5.6%
Missing	0
Missing (%)	0.0%
Memory size	520.0 KiB

Minimum	2010-01-02 00:00:00
Maximum	2020-04-09 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Number of Days
Real number (ℝ)

Distinct	70
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.2337656

Minimum	1
Maximum	97
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	520.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	8
Maximum	97
Range	96
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	3.3778544
Coefficient of variation (CV)	1.0445576
Kurtosis	116.33974
Mean	3.2337656
Median Absolute Deviation (MAD)	1
Skewness	6.8337792
Sum	215178
Variance	11.4099
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	28254	42.5%
3	11506	17.3%
2	6648	10.0%
7	6473	9.7%
4	3888	5.8%
8	2430	3.7%
9	2406	3.6%
5	2180	3.3%
6	2176	3.3%
12	47	0.1%
Other values (60)	533	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	28254	42.5%
2	6648	10.0%
3	11506	17.3%
4	3888	5.8%
5	2180	3.3%
6	2176	3.3%
7	6473	9.7%
8	2430	3.7%
9	2406	3.6%
10	39	0.1%

Value	Count	Frequency (%)
97	2	< 0.1%
96	1	< 0.1%
93	1	< 0.1%
91	1	< 0.1%
90	1	< 0.1%
89	1	< 0.1%
88	1	< 0.1%
83	1	< 0.1%
82	1	< 0.1%
75	1	< 0.1%

Check-Out Date
Date

Distinct	3748
Distinct (%)	5.6%
Missing	0
Missing (%)	0.0%
Memory size	520.0 KiB

Minimum	2010-01-03 00:00:00
Maximum	2020-04-13 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Rooms
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

2	19095
1	19070
3	18828
4	9548

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	66541
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	2
3rd row	2
4th row	2
5th row	3

Common Values

Value	Count	Frequency (%)
2	19095	28.7%
1	19070	28.7%
3	18828	28.3%
4	9548	14.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	19095	28.7%
1	19070	28.7%
3	18828	28.3%
4	9548	14.3%

Most occurring characters

Value	Count	Frequency (%)
2	19095	28.7%
1	19070	28.7%
3	18828	28.3%
4	9548	14.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	66541	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	19095	28.7%
1	19070	28.7%
3	18828	28.3%
4	9548	14.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	66541	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	19095	28.7%
1	19070	28.7%
3	18828	28.3%
4	9548	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	66541	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	19095	28.7%
1	19070	28.7%
3	18828	28.3%
4	9548	14.3%

Hotel Name
Text

Distinct	614
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	4.6 MiB

Length

Max length	38
Median length	30
Mean length	15.208172
Min length	4

Characters and Unicode

Total characters	1011967
Distinct characters	61
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Hotel Triton
2nd row	Enchanted Isle
3rd row	Seacoast Hotel
4th row	Night In Paradise
5th row	Tiny Digs Hotel

Value	Count	Frequency (%)
hotel	18416	10.8%
the	13232	7.8%
inn	5403	3.2%
resort	4887	2.9%
motel	4261	2.5%
b&b	3279	1.9%
suites	2075	1.2%
hotels	2028	1.2%
	1870	1.1%
home	1379	0.8%
Other values (690)	113158	66.6%

Most occurring characters

Value	Count	Frequency (%)
e	116560	11.5%
	103447	10.2%
o	79346	7.8%
t	69017	6.8%
l	61496	6.1%
a	59176	5.8%
n	50837	5.0%
r	46314	4.6%
s	44650	4.4%
i	41829	4.1%
Other values (51)	339295	33.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	729924	72.1%
Uppercase Letter	171613	17.0%
Space Separator	103447	10.2%
Other Punctuation	5232	0.5%
Final Punctuation	1097	0.1%
Decimal Number	335	< 0.1%
Dash Punctuation	319	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	116560	16.0%
o	79346	10.9%
t	69017	9.5%
l	61496	8.4%
a	59176	8.1%
n	50837	7.0%
r	46314	6.3%
s	44650	6.1%
i	41829	5.7%
h	23774	3.3%
Other values (17)	136925	18.8%

Uppercase Letter

Value	Count	Frequency (%)
H	30729	17.9%
T	17285	10.1%
B	16317	9.5%
S	15621	9.1%
R	12470	7.3%
M	11184	6.5%
C	8489	4.9%
I	8048	4.7%
P	7542	4.4%
A	5585	3.3%
Other values (16)	38343	22.3%

Decimal Number

Value	Count	Frequency (%)
6	131	39.1%
5	102	30.4%
1	102	30.4%

Other Punctuation

Value	Count	Frequency (%)
&	5149	98.4%
.	83	1.6%

Space Separator

Value	Count	Frequency (%)
	103447	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	1097	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	319	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	901537	89.1%
Common	110430	10.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	116560	12.9%
o	79346	8.8%
t	69017	7.7%
l	61496	6.8%
a	59176	6.6%
n	50837	5.6%
r	46314	5.1%
s	44650	5.0%
i	41829	4.6%
H	30729	3.4%
Other values (43)	301583	33.5%

Common

Value	Count	Frequency (%)
	103447	93.7%
&	5149	4.7%
’	1097	1.0%
-	319	0.3%
6	131	0.1%
5	102	0.1%
1	102	0.1%
.	83	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1010776	99.9%
Punctuation	1097	0.1%
Latin 1 Sup	94	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	116560	11.5%
	103447	10.2%
o	79346	7.9%
t	69017	6.8%
l	61496	6.1%
a	59176	5.9%
n	50837	5.0%
r	46314	4.6%
s	44650	4.4%
i	41829	4.1%
Other values (49)	338104	33.4%

Punctuation

Value	Count	Frequency (%)
’	1097	100.0%

Latin 1 Sup

Value	Count	Frequency (%)
è	94	100.0%

Hotel Rating
Real number (ℝ)

HIGH CORRELATION

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.2885003

Minimum	3.3
Maximum	4.7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	520.0 KiB

Quantile statistics

Minimum	3.3
5-th percentile	3.8
Q1	4.2
median	4.3
Q3	4.5
95-th percentile	4.6
Maximum	4.7
Range	1.4
Interquartile range (IQR)	0.3

Descriptive statistics

Standard deviation	0.2755163
Coefficient of variation (CV)	0.064245373
Kurtosis	1.7803154
Mean	4.2885003
Median Absolute Deviation (MAD)	0.2
Skewness	-1.166679
Sum	285361.1
Variance	0.075909234
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
4.2	12425	18.7%
4.6	10725	16.1%
4.5	9681	14.5%
4.3	9349	14.0%
4.4	8376	12.6%
4.1	6570	9.9%
3.8	4134	6.2%
3.9	1355	2.0%
3.7	1347	2.0%
3.3	1296	1.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.3	1296	1.9%
3.7	1347	2.0%
3.8	4134	6.2%
3.9	1355	2.0%
4.1	6570	9.9%
4.2	12425	18.7%
4.3	9349	14.0%
4.4	8376	12.6%
4.5	9681	14.5%
4.6	10725	16.1%

Value	Count	Frequency (%)
4.7	1283	1.9%
4.6	10725	16.1%
4.5	9681	14.5%
4.4	8376	12.6%
4.3	9349	14.0%
4.2	12425	18.7%
4.1	6570	9.9%
3.9	1355	2.0%
3.8	4134	6.2%
3.7	1347	2.0%

Payment Mode
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Internet Banking	13446
Debit Card	13363
Wallet	13317
Credit Card	13267
COD	13148

Length

Max length	16
Median length	10
Mean length	9.22813
Min length	3

Characters and Unicode

Total characters	614049
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Wallet
2nd row	Wallet
3rd row	Credit Card
4th row	Debit Card
5th row	Wallet

Common Values

Value	Count	Frequency (%)
Internet Banking	13446	20.2%
Debit Card	13363	20.1%
Wallet	13317	20.0%
Credit Card	13267	19.9%
COD	13148	19.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
card	26630	25.0%
internet	13446	12.6%
banking	13446	12.6%
debit	13363	12.5%
wallet	13317	12.5%
credit	13267	12.4%
cod	13148	12.3%

Most occurring characters

Value	Count	Frequency (%)
t	66839	10.9%
e	66839	10.9%
n	53784	8.8%
a	53393	8.7%
r	53343	8.7%
C	53045	8.6%
i	40076	6.5%
	40076	6.5%
d	39897	6.5%
l	26634	4.3%
Other values (8)	120123	19.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	441060	71.8%
Uppercase Letter	132913	21.6%
Space Separator	40076	6.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	66839	15.2%
e	66839	15.2%
n	53784	12.2%
a	53393	12.1%
r	53343	12.1%
i	40076	9.1%
d	39897	9.0%
l	26634	6.0%
g	13446	3.0%
k	13446	3.0%

Uppercase Letter

Value	Count	Frequency (%)
C	53045	39.9%
D	26511	19.9%
I	13446	10.1%
B	13446	10.1%
W	13317	10.0%
O	13148	9.9%

Space Separator

Value	Count	Frequency (%)
	40076	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	573973	93.5%
Common	40076	6.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	66839	11.6%
e	66839	11.6%
n	53784	9.4%
a	53393	9.3%
r	53343	9.3%
C	53045	9.2%
i	40076	7.0%
d	39897	7.0%
l	26634	4.6%
D	26511	4.6%
Other values (7)	93612	16.3%

Common

Value	Count	Frequency (%)
	40076	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	614049	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	66839	10.9%
e	66839	10.9%
n	53784	8.8%
a	53393	8.7%
r	53343	8.7%
C	53045	8.6%
i	40076	6.5%
	40076	6.5%
d	39897	6.5%
l	26634	4.3%
Other values (8)	120123	19.6%

Bank Name
Categorical

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.3 MiB

United Overseas Bank (UOB)	7500
Cash	7491
DBS Bank	7467
Bank of Singapore (BOS)	7466
HSBC	7379
Other values (4)	29238

Length

Max length	26
Median length	10
Mean length	10.599811
Min length	4

Characters and Unicode

Total characters	705322
Distinct characters	36
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	United Overseas Bank (UOB)
2nd row	EZ-Link
3rd row	Grab
4th row	DBS Paylah
5th row	Bank of Singapore (BOS)

Common Values

Value	Count	Frequency (%)
United Overseas Bank (UOB)	7500	11.3%
Cash	7491	11.3%
DBS Bank	7467	11.2%
Bank of Singapore (BOS)	7466	11.2%
HSBC	7379	11.1%
DBS Paylah	7330	11.0%
CITI Bank	7322	11.0%
Grab	7304	11.0%
EZ-Link	7282	10.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
bank	29755	22.3%
dbs	14797	11.1%
united	7500	5.6%
overseas	7500	5.6%
uob	7500	5.6%
cash	7491	5.6%
of	7466	5.6%
singapore	7466	5.6%
bos	7466	5.6%
hsbc	7379	5.5%
Other values (4)	29238	21.9%

Most occurring characters

Value	Count	Frequency (%)
a	74176	10.5%
	67017	9.5%
B	66897	9.5%
n	52003	7.4%
S	37108	5.3%
k	37037	5.3%
e	29966	4.2%
s	22491	3.2%
O	22466	3.2%
r	22270	3.2%
Other values (26)	273891	38.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	356806	50.6%
Uppercase Letter	244285	34.6%
Space Separator	67017	9.5%
Open Punctuation	14966	2.1%
Close Punctuation	14966	2.1%
Dash Punctuation	7282	1.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	74176	20.8%
n	52003	14.6%
k	37037	10.4%
e	29966	8.4%
s	22491	6.3%
r	22270	6.2%
i	22248	6.2%
o	14932	4.2%
h	14821	4.2%
v	7500	2.1%
Other values (8)	59362	16.6%

Uppercase Letter

Value	Count	Frequency (%)
B	66897	27.4%
S	37108	15.2%
O	22466	9.2%
C	22192	9.1%
U	15000	6.1%
D	14797	6.1%
I	14644	6.0%
H	7379	3.0%
P	7330	3.0%
T	7322	3.0%
Other values (4)	29150	11.9%

Space Separator

Value	Count	Frequency (%)
	67017	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	14966	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	14966	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	7282	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	601091	85.2%
Common	104231	14.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	74176	12.3%
B	66897	11.1%
n	52003	8.7%
S	37108	6.2%
k	37037	6.2%
e	29966	5.0%
s	22491	3.7%
O	22466	3.7%
r	22270	3.7%
i	22248	3.7%
Other values (22)	214429	35.7%

Common

Value	Count	Frequency (%)
	67017	64.3%
(	14966	14.4%
)	14966	14.4%
-	7282	7.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	705322	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	74176	10.5%
	67017	9.5%
B	66897	9.5%
n	52003	7.4%
S	37108	5.3%
k	37037	5.3%
e	29966	4.2%
s	22491	3.2%
O	22466	3.2%
r	22270	3.2%
Other values (26)	273891	38.8%

Booking Price[SGD]
Real number (ℝ)

HIGH CORRELATION

Distinct	491
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	214.04678

Minimum	35
Maximum	578
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	520.0 KiB

Quantile statistics

Minimum	35
5-th percentile	56
Q1	125
median	199
Q3	293
95-th percentile	407
Maximum	578
Range	543
Interquartile range (IQR)	168

Descriptive statistics

Standard deviation	108.12618
Coefficient of variation (CV)	0.50515211
Kurtosis	-0.70140534
Mean	214.04678
Median Absolute Deviation (MAD)	83
Skewness	0.38855539
Sum	14242887
Variance	11691.272
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
290	630	0.9%
160	613	0.9%
161	595	0.9%
318	565	0.8%
158	556	0.8%
97	538	0.8%
115	516	0.8%
289	514	0.8%
131	512	0.8%
173	491	0.7%
Other values (481)	61011	91.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
35	62	0.1%
36	62	0.1%
37	70	0.1%
38	193	0.3%
39	72	0.1%
40	169	0.3%
41	109	0.2%
42	139	0.2%
43	139	0.2%
44	146	0.2%

Value	Count	Frequency (%)
578	2	< 0.1%
576	2	< 0.1%
575	1	< 0.1%
571	1	< 0.1%
568	1	< 0.1%
564	1	< 0.1%
562	1	< 0.1%
558	1	< 0.1%
554	1	< 0.1%
553	1	< 0.1%

Discount
Real number (ℝ)

ZEROS

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.12546956

Minimum	0
Maximum	0.25
Zeros	2547
Zeros (%)	3.8%
Negative	0
Negative (%)	0.0%
Memory size	520.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.01
Q1	0.06
median	0.13
Q3	0.19
95-th percentile	0.24
Maximum	0.25
Range	0.25
Interquartile range (IQR)	0.13

Descriptive statistics

Standard deviation	0.075112945
Coefficient of variation (CV)	0.59865473
Kurtosis	-1.2068243
Mean	0.12546956
Median Absolute Deviation (MAD)	0.07
Skewness	-0.010747477
Sum	8348.87
Variance	0.0056419545
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
0.2	2716	4.1%
0.01	2660	4.0%
0.09	2650	4.0%
0.21	2634	4.0%
0.12	2625	3.9%
0.22	2624	3.9%
0.19	2611	3.9%
0.11	2603	3.9%
0.23	2595	3.9%
0.15	2587	3.9%
Other values (16)	40236	60.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2547	3.8%
0.01	2660	4.0%
0.02	2495	3.7%
0.03	2482	3.7%
0.04	2577	3.9%
0.05	2543	3.8%
0.06	2512	3.8%
0.07	2473	3.7%
0.08	2435	3.7%
0.09	2650	4.0%

Value	Count	Frequency (%)
0.25	2575	3.9%
0.24	2529	3.8%
0.23	2595	3.9%
0.22	2624	3.9%
0.21	2634	4.0%
0.2	2716	4.1%
0.19	2611	3.9%
0.18	2493	3.7%
0.17	2462	3.7%
0.16	2460	3.7%

Taxes (GST)
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.9 MiB

0.07	66541

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	266164
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.07
2nd row	0.07
3rd row	0.07
4th row	0.07
5th row	0.07

Common Values

Value	Count	Frequency (%)
0.07	66541	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.07	66541	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	133082	50.0%
.	66541	25.0%
7	66541	25.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	199623	75.0%
Other Punctuation	66541	25.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	133082	66.7%
7	66541	33.3%

Other Punctuation

Value	Count	Frequency (%)
.	66541	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	266164	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	133082	50.0%
.	66541	25.0%
7	66541	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	266164	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	133082	50.0%
.	66541	25.0%
7	66541	25.0%

Profit Margin
Real number (ℝ)

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.18881652

Minimum	0.1
Maximum	0.3
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	520.0 KiB

Quantile statistics

Minimum	0.1
5-th percentile	0.1
Q1	0.14
median	0.2
Q3	0.23
95-th percentile	0.28
Maximum	0.3
Range	0.2
Interquartile range (IQR)	0.09

Descriptive statistics

Standard deviation	0.05276504
Coefficient of variation (CV)	0.27945139
Kurtosis	-0.86690274
Mean	0.18881652
Median Absolute Deviation (MAD)	0.04
Skewness	0.082602761
Sum	12564.04
Variance	0.0027841494
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0.22	9358	14.1%
0.14	6853	10.3%
0.2	5409	8.1%
0.24	5404	8.1%
0.25	5356	8.0%
0.13	5320	8.0%
0.16	4075	6.1%
0.1	4041	6.1%
0.17	3305	5.0%
0.19	3030	4.6%
Other values (7)	14390	21.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.1	4041	6.1%
0.11	2744	4.1%
0.13	5320	8.0%
0.14	6853	10.3%
0.15	2547	3.8%
0.16	4075	6.1%
0.17	3305	5.0%
0.18	1243	1.9%
0.19	3030	4.6%
0.2	5409	8.1%

Value	Count	Frequency (%)
0.3	2702	4.1%
0.28	1296	1.9%
0.25	5356	8.0%
0.24	5404	8.1%
0.23	2578	3.9%
0.22	9358	14.1%
0.21	1280	1.9%
0.2	5409	8.1%
0.19	3030	4.6%
0.18	1243	1.9%

Auto

Heatmap
Table

	Age	Bank Name	Booking Price[SGD]	Destination Country	Discount	Gender	Hotel Rating	No. Of People	Number of Days	Origin Country	Payment Mode	Profit Margin	Rooms
Age	1.000	0.012	-0.002	0.013	0.013	0.000	-0.002	0.006	-0.003	0.000	0.005	0.000	0.008
Bank Name	0.012	1.000	-0.001	0.017	0.001	0.016	0.001	0.004	-0.005	0.000	0.008	0.002	0.010
Booking Price[SGD]	-0.002	-0.001	1.000	0.010	-0.002	0.000	0.541	-0.000	-0.039	0.000	0.000	-0.154	0.008
Destination Country	0.013	0.017	0.010	1.000	-0.006	0.014	-0.002	-0.002	-0.006	0.005	0.015	-0.003	0.006
Discount	0.013	0.001	-0.002	-0.006	1.000	0.012	0.005	0.005	0.000	0.000	0.009	-0.003	0.010
Gender	0.000	0.016	0.000	0.014	0.012	1.000	-0.003	-0.005	0.001	0.000	0.014	0.006	0.010
Hotel Rating	-0.002	0.001	0.541	-0.002	0.005	-0.003	1.000	-0.002	-0.008	0.000	0.010	-0.371	0.011
No. Of People	0.006	0.004	-0.000	-0.002	0.005	-0.005	-0.002	1.000	-0.003	0.001	0.006	0.006	1.000
Number of Days	-0.003	-0.005	-0.039	-0.006	0.000	0.001	-0.008	-0.003	1.000	0.000	0.007	-0.002	0.002
Origin Country	0.000	0.000	0.000	0.005	0.000	0.000	0.000	0.001	0.000	1.000	0.002	0.005	0.000
Payment Mode	0.005	0.008	0.000	0.015	0.009	0.014	0.010	0.006	0.007	0.002	1.000	0.001	0.004
Profit Margin	0.000	0.002	-0.154	-0.003	-0.003	0.006	-0.371	0.006	-0.002	0.005	0.001	1.000	0.012
Rooms	0.008	0.010	0.008	0.006	0.010	0.010	0.011	1.000	0.002	0.000	0.004	0.012	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Booking ID	Date of Booking	Time	Customer ID	Gender	Age	Origin Country	State	Location	Destination Country	Destination City	No. Of People	Check-in date	Number of Days	Check-Out Date	Rooms	Hotel Name	Hotel Rating	Payment Mode	Bank Name	Booking Price[SGD]	Discount	Taxes (GST)	Profit Margin
0	DDMY00001	2010-01-01	10:49:40	MY00001	Male	42	Malaysia	Johor	Iskandar Puteri	Denmark	Horsens	1	2010-01-12	8	2010-01-20	1	Hotel Triton	4.3	Wallet	United Overseas Bank (UOB)	243	0.01	0.07	0.25
1	DDID00002	2010-01-01	09:19:47	ID00001	Female	44	Indonesia	Ciawi	West Java	Colombia	Medellin	3	2010-01-21	1	2010-01-22	2	Enchanted Isle	4.2	Wallet	EZ-Link	312	0.00	0.07	0.24
2	DDSG00003	2010-01-01	11:52:56	SG00001	Female	31	Singapore	Central	Rochor	Germany	Munich	3	2010-01-02	7	2010-01-09	2	Seacoast Hotel	4.5	Credit Card	Grab	338	0.19	0.07	0.20
3	DDSG00004	2010-01-01	13:44:40	SG00002	Male	28	Singapore	North	Yishun	Canada	Montreal	3	2010-02-15	4	2010-02-19	2	Night In Paradise	4.2	Debit Card	DBS Paylah	254	0.19	0.07	0.13
4	DDKH00005	2010-01-01	05:38:26	KH00001	Male	44	Cambodia	Phnom Trop	Pursat	Kenya	Nairobi	5	2010-01-03	3	2010-01-06	3	Tiny Digs Hotel	4.6	Wallet	Bank of Singapore (BOS)	313	0.15	0.07	0.17
5	DDTH00006	2010-01-01	05:41:55	TH00001	Male	32	Thailand	Chiang Mai	Chiang Mai	Canada	Toronto	2	2010-01-28	1	2010-01-29	1	Seascape	4.5	Internet Banking	United Overseas Bank (UOB)	161	0.01	0.07	0.15
6	DDTH00007	2010-01-01	20:14:21	TH00002	Male	49	Thailand	Surat Thani	Surat Thani	Iran	Tehran	3	2010-03-15	3	2010-03-18	2	Waldorf Astoria	4.6	Debit Card	HSBC	313	0.10	0.07	0.17
7	DDMY00008	2010-01-01	00:22:07	MY00002	Female	58	Malaysia	Sarawak	Kuching	Egypt	Port Said	4	2010-01-03	1	2010-01-04	2	The Westgate Hotel	4.1	Wallet	Cash	121	0.05	0.07	0.15
8	DDSG00009	2010-01-01	09:30:32	SG00003	Male	57	Singapore	North	Mandai	Egypt	Luxor	4	2010-04-09	3	2010-04-12	2	Firefly Motel	4.4	COD	EZ-Link	173	0.20	0.07	0.22
9	DDSG00010	2010-01-01	16:22:39	SG00004	Female	41	Singapore	West	Tengah	France	Marseille	4	2010-01-07	2	2010-01-09	2	Cape Grace	4.7	Credit Card	Grab	309	0.16	0.07	0.25

	Booking ID	Date of Booking	Time	Customer ID	Gender	Age	Origin Country	State	Location	Destination Country	Destination City	No. Of People	Check-in date	Number of Days	Check-Out Date	Rooms	Hotel Name	Hotel Rating	Payment Mode	Bank Name	Booking Price[SGD]	Discount	Taxes (GST)	Profit Margin
66531	DDVN66526	2019-12-31	15:27:30	VN05957	Male	52	Vietnam	Phan Thiet	Binh Thuan	Israel	Holon	2	2020-01-01	1	2020-01-02	1	Slumber Falls	3.8	Debit Card	Grab	115	0.07	0.07	0.25
66532	DDID66527	2019-12-31	04:18:40	ID11986	Female	30	Indonesia	Senayan	Jakarta	Israel	Beersheba	4	2020-03-28	1	2020-03-29	2	Creek Quest	3.8	COD	DBS Paylah	120	0.00	0.07	0.22
66533	DDMY66528	2019-12-31	17:53:01	MY12048	Male	46	Malaysia	Kedah	Alor Setar	Canada	Ottawa	5	2020-01-01	3	2020-01-04	3	Hotel Triton	4.1	Credit Card	HSBC	159	0.14	0.07	0.22
66534	DDVN66529	2019-12-31	04:31:42	VN05958	Female	19	Vietnam	Dien Ban	Quang Nam	Maldives	Thinadhoo	1	2020-01-01	1	2020-01-02	1	The Hot Springs Hotel	3.8	Internet Banking	Bank of Singapore (BOS)	116	0.14	0.07	0.22
66535	DDMY66530	2019-12-31	04:15:03	MY12049	Male	46	Malaysia	Johor	Johor Bahru	Iceland	Reykjavik	3	2020-01-09	1	2020-01-10	2	Hotel The Pie	4.2	Debit Card	DBS Bank	181	0.15	0.07	0.10
66536	DDSG66531	2019-12-31	23:36:16	SG12034	Female	42	Singapore	Central	Orchard	Germany	Berlin	4	2020-01-06	4	2020-01-10	2	Silver Cloud Inn	4.3	Wallet	Grab	182	0.23	0.07	0.24
66537	DDSG66532	2019-12-31	14:41:01	SG12035	Female	54	Singapore	Central	Geylang	Israel	Holon	4	2020-04-09	4	2020-04-13	2	The Elet	4.2	COD	DBS Paylah	125	0.06	0.07	0.19
66538	DDSG66533	2019-12-31	19:11:16	SG12036	Female	57	Singapore	Central	Downtown Core	Canada	Ottawa	7	2020-01-09	1	2020-01-10	4	The Elet	4.4	Debit Card	EZ-Link	318	0.02	0.07	0.22
66539	DDTH66534	2019-12-31	05:12:29	TH12170	Female	44	Thailand	Surat Thani	Ko Samui	Maldives	Viligili	3	2020-01-01	1	2020-01-02	2	Sunset Lodge	4.2	Debit Card	HSBC	173	0.14	0.07	0.25
66540	DDVN66535	2019-12-31	00:51:52	VN05959	Female	52	Vietnam	Pleiku	Gia Lai	Egypt	Luxor	5	2020-01-24	4	2020-01-28	3	Coastal bay hotel	4.3	Internet Banking	Grab	182	0.17	0.07	0.24

Most frequently occurring

	Booking ID	Date of Booking	Customer ID	Gender	Age	Origin Country	State	Location	Destination Country	Destination City	No. Of People	Check-in date	Number of Days	Check-Out Date	Rooms	Hotel Name	Hotel Rating	Payment Mode	Bank Name	Booking Price[SGD]	Discount	Taxes (GST)	Profit Margin	# duplicates
3	DDVN34340	2016-02-23	VN03010	Male	38	Vietnam	Pleiku	Gia Lai	Italy	Rome	4	2016-03-19	4	2016-03-23	2	Hotel Lucia	4.4	Credit Card	HSBC	170	0.10	0.07	0.22	3
0	DDKH50738	2018-04-14	KH04520	Male	46	Cambodia	Krang Yov	Kandal	New Zealand	Dunedin	4	2018-04-23	7	2018-04-30	2	The Fresco Hotel	3.8	Internet Banking	EZ-Link	99	0.06	0.07	0.22	2
1	DDMY00008	2010-01-01	MY00002	Female	58	Malaysia	Sarawak	Kuching	Egypt	Port Said	4	2010-01-03	1	2010-01-04	2	The Westgate Hotel	4.1	Wallet	Cash	121	0.05	0.07	0.15	2
2	DDSG22537	2014-03-23	SG04062	Male	41	Singapore	Central	Geylang	Germany	Essen	2	2014-03-24	1	2014-03-25	1	Royal Orbit	4.2	Wallet	HSBC	48	0.17	0.07	0.19	2

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Dash Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks